SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[usp_GetRecruitLarge]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	SELECT  TOP 5 id,topic, update_time,start_time FROM dbo.JOL_Recruitment 
	WHERE type='大型招聘会' AND state=1
	 ORDER BY start_time DESC, update_time desc
	RETURN



GO
